﻿CREATE TABLE [Queue].[ProcessType]
(
	[ProcessTypeID] BIGINT IDENTITY(1,1) NOT NULL CONSTRAINT [QUEUE_ProcessType_ProcessTypeID] PRIMARY KEY,
	[Enum] NVARCHAR(250) NOT NULL CONSTRAINT [QUEUE_ProcessType_Enum] UNIQUE,
	[EnumDesc] NVARCHAR(500) NOT NULL CONSTRAINT [QUEUE_ProcessType_Description] DEFAULT ('NONE'),
	[CreatedBy] NVARCHAR(250) NOT NULL CONSTRAINT [QUEUE_ProcessType_CreatedBy] DEFAULT SYSTEM_USER,	
	[DateCreated] DATETIME NOT NULL CONSTRAINT [QUEUE_ProcessType_DateCreated] DEFAULT GETDATE(), 
	[DateDeleted] DATETIME NULL,
	[VersionUser] NVARCHAR(250) NOT NULL CONSTRAINT [QUEUE_ProcessType_VersionUser] DEFAULT SYSTEM_USER,
	[VersionDate] DATETIME NOT NULL CONSTRAINT [QUEUE_ProcessType_VersionDate] DEFAULT GETDATE()
)